Executes an SQL query using the specified connection string.
Syntax
ExecSQL(Connection As String, Query As String, [Parameters])
Name | Description |
---|---|
Connection |
A valid connection string for the database with which to execute the query. This parameter also accepts a variable that represents one of the following vault databases described in the table. The variables are case-sensitive. $$TransManDB – The Transmittal Management Module database (if installed) $$UserDB – The user account database Note When the Use Enterprise Server for user management option is enabled in the EDM Server properties in Meridian Enterprise Administrator, the reserved word $$UserDB cannot be used in VBScript with the Vault.ExecSQL method to access the Meridian Enterprise Server user database. $$<QueryName> – An external table query connection string created as described in the BlueCielo Meridian Enterprise Configuration Guide. |
Query |
A valid SQL query expression. |
Parameters |
Optional parameters. |
Related concepts